Dataset statistics
| Number of variables | 25 |
|---|---|
| Number of observations | 34493 |
| Missing cells | 310496 |
| Missing cells (%) | 36.0% |
| Duplicate rows | 0 |
| Duplicate rows (%) | 0.0% |
| Total size in memory | 26.1 MiB |
| Average record size in memory | 793.2 B |
Variable types
| Categorical | 10 |
|---|---|
| Numeric | 12 |
| Unsupported | 3 |
ClaseVehiculo__c has constant value "99999" | Constant |
TipoVehiculo__c has constant value "99999" | Constant |
n_prod_prev is highly correlated with total_siniestros and 2 other fields | High correlation |
total_siniestros is highly correlated with n_prod_prev and 2 other fields | High correlation |
total_pagado_smmlv is highly correlated with n_prod_prev and 3 other fields | High correlation |
anios_ultimo_siniestro is highly correlated with n_prod_prev and 2 other fields | High correlation |
Activos__c is highly correlated with AnnualRevenue and 1 other fields | High correlation |
AnnualRevenue is highly correlated with Activos__c and 1 other fields | High correlation |
MontoAnual__c is highly correlated with total_pagado_smmlv | High correlation |
EgresosAnuales__c is highly correlated with Activos__c and 1 other fields | High correlation |
total_siniestros is highly correlated with total_pagado_smmlv and 1 other fields | High correlation |
total_pagado_smmlv is highly correlated with total_siniestros and 1 other fields | High correlation |
anios_ultimo_siniestro is highly correlated with total_siniestros and 1 other fields | High correlation |
AnnualRevenue is highly correlated with EgresosAnuales__c | High correlation |
EgresosAnuales__c is highly correlated with AnnualRevenue | High correlation |
total_siniestros is highly correlated with total_pagado_smmlv and 1 other fields | High correlation |
total_pagado_smmlv is highly correlated with total_siniestros and 2 other fields | High correlation |
anios_ultimo_siniestro is highly correlated with total_siniestros and 1 other fields | High correlation |
AnnualRevenue is highly correlated with EgresosAnuales__c | High correlation |
MontoAnual__c is highly correlated with total_pagado_smmlv | High correlation |
EgresosAnuales__c is highly correlated with AnnualRevenue | High correlation |
FechaInicioVigencia__ctrim is highly correlated with TipoVehiculo__c and 2 other fields | High correlation |
CodigoTipoAsegurado__c is highly correlated with TipoVehiculo__c and 4 other fields | High correlation |
TipoVehiculo__c is highly correlated with FechaInicioVigencia__ctrim and 8 other fields | High correlation |
ciudad_name is highly correlated with CodigoTipoAsegurado__c and 2 other fields | High correlation |
tipo_ramo_name is highly correlated with TipoVehiculo__c and 2 other fields | High correlation |
tipo_prod_desc is highly correlated with TipoVehiculo__c and 2 other fields | High correlation |
Genero__pc is highly correlated with CodigoTipoAsegurado__c and 3 other fields | High correlation |
churn is highly correlated with FechaInicioVigencia__ctrim and 2 other fields | High correlation |
ClaseVehiculo__c is highly correlated with FechaInicioVigencia__ctrim and 8 other fields | High correlation |
EstadoCivil__pc is highly correlated with CodigoTipoAsegurado__c and 3 other fields | High correlation |
PuntoVenta__c is highly correlated with n_prod_prev and 2 other fields | High correlation |
tipo_ramo_name is highly correlated with tipo_prod_desc and 1 other fields | High correlation |
tipo_prod_desc is highly correlated with tipo_ramo_name and 1 other fields | High correlation |
NumeroPoliza__c is highly correlated with tipo_ramo_name and 1 other fields | High correlation |
FechaInicioVigencia__ctrim is highly correlated with churn | High correlation |
churn is highly correlated with FechaInicioVigencia__ctrim | High correlation |
n_prod_prev is highly correlated with PuntoVenta__c and 3 other fields | High correlation |
total_siniestros is highly correlated with PuntoVenta__c and 2 other fields | High correlation |
total_pagado_smmlv is highly correlated with PuntoVenta__c and 3 other fields | High correlation |
anios_ultimo_siniestro is highly correlated with n_prod_prev and 2 other fields | High correlation |
AnnualRevenue is highly correlated with EgresosAnuales__c | High correlation |
MontoAnual__c is highly correlated with edad | High correlation |
OtrosIngresos__c is highly correlated with anios_ultimo_siniestro | High correlation |
EgresosAnuales__c is highly correlated with AnnualRevenue | High correlation |
EstadoCivil__pc is highly correlated with Genero__pc | High correlation |
Genero__pc is highly correlated with EstadoCivil__pc | High correlation |
edad is highly correlated with MontoAnual__c | High correlation |
MarcaVehiculo__c has 34493 (100.0%) missing values | Missing |
MdeloVehiculo__c has 34493 (100.0%) missing values | Missing |
n_prod_prev has 1130 (3.3%) missing values | Missing |
total_siniestros has 18691 (54.2%) missing values | Missing |
total_pagado_smmlv has 18691 (54.2%) missing values | Missing |
anios_ultimo_siniestro has 18691 (54.2%) missing values | Missing |
Activos__c has 14407 (41.8%) missing values | Missing |
AnnualRevenue has 14407 (41.8%) missing values | Missing |
MontoAnual__c has 34473 (99.9%) missing values | Missing |
OtrosIngresos__c has 15501 (44.9%) missing values | Missing |
Profesion__pc has 34493 (100.0%) missing values | Missing |
EgresosAnuales__c has 14407 (41.8%) missing values | Missing |
EstadoCivil__pc has 14147 (41.0%) missing values | Missing |
Genero__pc has 14147 (41.0%) missing values | Missing |
ciudad_name has 14147 (41.0%) missing values | Missing |
edad has 14178 (41.1%) missing values | Missing |
Activos__c is highly skewed (γ1 = 96.7181334) | Skewed |
AnnualRevenue is highly skewed (γ1 = 22.54403697) | Skewed |
OtrosIngresos__c is highly skewed (γ1 = 98.99998221) | Skewed |
MarcaVehiculo__c is an unsupported type, check if it needs cleaning or further analysis | Unsupported |
MdeloVehiculo__c is an unsupported type, check if it needs cleaning or further analysis | Unsupported |
Profesion__pc is an unsupported type, check if it needs cleaning or further analysis | Unsupported |
total_pagado_smmlv has 1697 (4.9%) zeros | Zeros |
OtrosIngresos__c has 18238 (52.9%) zeros | Zeros |
Reproduction
| Analysis started | 2022-06-07 22:28:51.733354 |
|---|---|
| Analysis finished | 2022-06-07 22:34:15.833355 |
| Duration | 5 minutes and 24.1 seconds |
| Software version | pandas-profiling v3.2.0 |
| Download configuration | config.json |
| Distinct | 4 |
|---|---|
| Distinct (%) | < 0.1% |
| Missing | 0 |
| Missing (%) | 0.0% |
| Memory size | 1.9 MiB |
| 1 | |
|---|---|
| 4 | 624 |
| 3 | 145 |
| 2 | 66 |
Length
| Max length | 1 |
|---|---|
| Median length | 1 |
| Mean length | 1 |
| Min length | 1 |
Characters and Unicode
| Total characters | 34493 |
|---|---|
| Distinct characters | 4 |
| Distinct categories | 1 ? |
| Distinct scripts | 1 ? |
| Distinct blocks | 1 ? |
Unique
| Unique | 0 ? |
|---|---|
| Unique (%) | 0.0% |
Sample
| 1st row | 2 |
|---|---|
| 2nd row | 4 |
| 3rd row | 2 |
| 4th row | 4 |
| 5th row | 1 |
Common Values
| Value | Count | Frequency (%) |
| 1 | 33658 | |
| 4 | 624 | 1.8% |
| 3 | 145 | 0.4% |
| 2 | 66 | 0.2% |
Length
Category Frequency Plot
| Value | Count | Frequency (%) |
| 1 | 33658 | |
| 4 | 624 | 1.8% |
| 3 | 145 | 0.4% |
| 2 | 66 | 0.2% |
Most occurring characters
| Value | Count | Frequency (%) |
| 1 | 33658 | |
| 4 | 624 | 1.8% |
| 3 | 145 | 0.4% |
| 2 | 66 | 0.2% |
Most occurring categories
| Value | Count | Frequency (%) |
| Decimal Number | 34493 |
Most frequent character per category
Decimal Number
| Value | Count | Frequency (%) |
| 1 | 33658 | |
| 4 | 624 | 1.8% |
| 3 | 145 | 0.4% |
| 2 | 66 | 0.2% |
Most occurring scripts
| Value | Count | Frequency (%) |
| Common | 34493 |
Most frequent character per script
Common
| Value | Count | Frequency (%) |
| 1 | 33658 | |
| 4 | 624 | 1.8% |
| 3 | 145 | 0.4% |
| 2 | 66 | 0.2% |
Most occurring blocks
| Value | Count | Frequency (%) |
| ASCII | 34493 |
Most frequent character per block
ASCII
| Value | Count | Frequency (%) |
| 1 | 33658 | |
| 4 | 624 | 1.8% |
| 3 | 145 | 0.4% |
| 2 | 66 | 0.2% |
| Distinct | 268 |
|---|---|
| Distinct (%) | 0.8% |
| Missing | 0 |
| Missing (%) | 0.0% |
| Infinite | 0 |
| Infinite (%) | 0.0% |
| Mean | 4164.068855 |
| Minimum | 5 |
|---|---|
| Maximum | 9977 |
| Zeros | 0 |
| Zeros (%) | 0.0% |
| Negative | 0 |
| Negative (%) | 0.0% |
| Memory size | 269.6 KiB |
Quantile statistics
| Minimum | 5 |
|---|---|
| 5-th percentile | 120 |
| Q1 | 1048 |
| median | 2707 |
| Q3 | 9474 |
| 95-th percentile | 9721 |
| Maximum | 9977 |
| Range | 9972 |
| Interquartile range (IQR) | 8426 |
Descriptive statistics
| Standard deviation | 3682.154548 |
|---|---|
| Coefficient of variation (CV) | 0.8842684108 |
| Kurtosis | -1.260203819 |
| Mean | 4164.068855 |
| Median Absolute Deviation (MAD) | 1705 |
| Skewness | 0.6623917598 |
| Sum | 143631227 |
| Variance | 13558262.12 |
| Monotonicity | Not monotonic |
| Value | Count | Frequency (%) |
| 9721 | 7160 | |
| 3301 | 1871 | 5.4% |
| 1048 | 1735 | 5.0% |
| 3202 | 1643 | 4.8% |
| 2466 | 1433 | 4.2% |
| 3502 | 1198 | 3.5% |
| 404 | 1170 | 3.4% |
| 301 | 1160 | 3.4% |
| 9474 | 692 | 2.0% |
| 501 | 553 | 1.6% |
| Other values (258) | 15878 |
| Value | Count | Frequency (%) |
| 5 | 133 | 0.4% |
| 8 | 32 | 0.1% |
| 9 | 54 | 0.2% |
| 14 | 140 | 0.4% |
| 16 | 121 | 0.4% |
| 23 | 504 | |
| 25 | 126 | 0.4% |
| 26 | 92 | 0.3% |
| 100 | 1 | < 0.1% |
| 102 | 9 | < 0.1% |
| Value | Count | Frequency (%) |
| 9977 | 8 | < 0.1% |
| 9973 | 1 | < 0.1% |
| 9971 | 75 | |
| 9969 | 51 | |
| 9967 | 9 | < 0.1% |
| 9943 | 5 | < 0.1% |
| 9849 | 53 | |
| 9838 | 6 | < 0.1% |
| 9830 | 1 | < 0.1% |
| 9821 | 8 | < 0.1% |
| Distinct | 2 |
|---|---|
| Distinct (%) | < 0.1% |
| Missing | 0 |
| Missing (%) | 0.0% |
| Memory size | 2.2 MiB |
| automoviles | |
|---|---|
| responsabilidad civil | 96 |
Length
| Max length | 21 |
|---|---|
| Median length | 11 |
| Mean length | 11.02783173 |
| Min length | 11 |
Characters and Unicode
| Total characters | 380383 |
|---|---|
| Distinct characters | 17 |
| Distinct categories | 2 ? |
| Distinct scripts | 2 ? |
| Distinct blocks | 1 ? |
Unique
| Unique | 0 ? |
|---|---|
| Unique (%) | 0.0% |
Sample
| 1st row | automoviles |
|---|---|
| 2nd row | automoviles |
| 3rd row | automoviles |
| 4th row | automoviles |
| 5th row | automoviles |
Common Values
| Value | Count | Frequency (%) |
| automoviles | 34397 | |
| responsabilidad civil | 96 | 0.3% |
Length
Category Frequency Plot
| Value | Count | Frequency (%) |
| automoviles | 34397 | |
| responsabilidad | 96 | 0.3% |
| civil | 96 | 0.3% |
Most occurring characters
| Value | Count | Frequency (%) |
| o | 68890 | |
| i | 34781 | |
| a | 34589 | |
| s | 34589 | |
| l | 34589 | |
| e | 34493 | |
| v | 34493 | |
| m | 34397 | |
| u | 34397 | |
| t | 34397 | |
| Other values (7) | 768 | 0.2% |
Most occurring categories
| Value | Count | Frequency (%) |
| Lowercase Letter | 380287 | |
| Space Separator | 96 | < 0.1% |
Most frequent character per category
Lowercase Letter
| Value | Count | Frequency (%) |
| o | 68890 | |
| i | 34781 | |
| a | 34589 | |
| s | 34589 | |
| l | 34589 | |
| e | 34493 | |
| v | 34493 | |
| m | 34397 | |
| u | 34397 | |
| t | 34397 | |
| Other values (6) | 672 | 0.2% |
Space Separator
| Value | Count | Frequency (%) |
| 96 |
Most occurring scripts
| Value | Count | Frequency (%) |
| Latin | 380287 | |
| Common | 96 | < 0.1% |
Most frequent character per script
Latin
| Value | Count | Frequency (%) |
| o | 68890 | |
| i | 34781 | |
| a | 34589 | |
| s | 34589 | |
| l | 34589 | |
| e | 34493 | |
| v | 34493 | |
| m | 34397 | |
| u | 34397 | |
| t | 34397 | |
| Other values (6) | 672 | 0.2% |
Common
| Value | Count | Frequency (%) |
| 96 |
Most occurring blocks
| Value | Count | Frequency (%) |
| ASCII | 380383 |
Most frequent character per block
ASCII
| Value | Count | Frequency (%) |
| o | 68890 | |
| i | 34781 | |
| a | 34589 | |
| s | 34589 | |
| l | 34589 | |
| e | 34493 | |
| v | 34493 | |
| m | 34397 | |
| u | 34397 | |
| t | 34397 | |
| Other values (7) | 768 | 0.2% |
| Distinct | 4 |
|---|---|
| Distinct (%) | < 0.1% |
| Missing | 0 |
| Missing (%) | 0.0% |
| Memory size | 2.2 MiB |
| automoviles | |
|---|---|
| profesionales medicos | 56 |
| directores y administradores | 38 |
| servidores publicos | 2 |
Length
| Max length | 28 |
|---|---|
| Median length | 11 |
| Mean length | 11.03542748 |
| Min length | 11 |
Characters and Unicode
| Total characters | 380645 |
|---|---|
| Distinct characters | 19 |
| Distinct categories | 2 ? |
| Distinct scripts | 2 ? |
| Distinct blocks | 1 ? |
Unique
| Unique | 0 ? |
|---|---|
| Unique (%) | 0.0% |
Sample
| 1st row | automoviles |
|---|---|
| 2nd row | automoviles |
| 3rd row | automoviles |
| 4th row | automoviles |
| 5th row | automoviles |
Common Values
| Value | Count | Frequency (%) |
| automoviles | 34397 | |
| profesionales medicos | 56 | 0.2% |
| directores y administradores | 38 | 0.1% |
| servidores publicos | 2 | < 0.1% |
Length
Category Frequency Plot
| Value | Count | Frequency (%) |
| automoviles | 34397 | |
| profesionales | 56 | 0.2% |
| medicos | 56 | 0.2% |
| directores | 38 | 0.1% |
| y | 38 | 0.1% |
| administradores | 38 | 0.1% |
| servidores | 2 | < 0.1% |
| publicos | 2 | < 0.1% |
Most occurring characters
| Value | Count | Frequency (%) |
| o | 69042 | |
| s | 34685 | |
| e | 34683 | |
| i | 34627 | |
| a | 34529 | |
| m | 34491 | |
| t | 34473 | |
| l | 34455 | |
| v | 34399 | |
| u | 34399 | |
| Other values (9) | 862 | 0.2% |
Most occurring categories
| Value | Count | Frequency (%) |
| Lowercase Letter | 380511 | |
| Space Separator | 134 | < 0.1% |
Most frequent character per category
Lowercase Letter
| Value | Count | Frequency (%) |
| o | 69042 | |
| s | 34685 | |
| e | 34683 | |
| i | 34627 | |
| a | 34529 | |
| m | 34491 | |
| t | 34473 | |
| l | 34455 | |
| v | 34399 | |
| u | 34399 | |
| Other values (8) | 728 | 0.2% |
Space Separator
| Value | Count | Frequency (%) |
| 134 |
Most occurring scripts
| Value | Count | Frequency (%) |
| Latin | 380511 | |
| Common | 134 | < 0.1% |
Most frequent character per script
Latin
| Value | Count | Frequency (%) |
| o | 69042 | |
| s | 34685 | |
| e | 34683 | |
| i | 34627 | |
| a | 34529 | |
| m | 34491 | |
| t | 34473 | |
| l | 34455 | |
| v | 34399 | |
| u | 34399 | |
| Other values (8) | 728 | 0.2% |
Common
| Value | Count | Frequency (%) |
| 134 |
Most occurring blocks
| Value | Count | Frequency (%) |
| ASCII | 380645 |
Most frequent character per block
ASCII
| Value | Count | Frequency (%) |
| o | 69042 | |
| s | 34685 | |
| e | 34683 | |
| i | 34627 | |
| a | 34529 | |
| m | 34491 | |
| t | 34473 | |
| l | 34455 | |
| v | 34399 | |
| u | 34399 | |
| Other values (9) | 862 | 0.2% |
| Distinct | 1 |
|---|---|
| Distinct (%) | < 0.1% |
| Missing | 0 |
| Missing (%) | 0.0% |
| Memory size | 2.0 MiB |
| 99999 |
|---|
Length
| Max length | 5 |
|---|---|
| Median length | 5 |
| Mean length | 5 |
| Min length | 5 |
Characters and Unicode
| Total characters | 172465 |
|---|---|
| Distinct characters | 1 |
| Distinct categories | 1 ? |
| Distinct scripts | 1 ? |
| Distinct blocks | 1 ? |
Unique
| Unique | 0 ? |
|---|---|
| Unique (%) | 0.0% |
Sample
| 1st row | 99999 |
|---|---|
| 2nd row | 99999 |
| 3rd row | 99999 |
| 4th row | 99999 |
| 5th row | 99999 |
Common Values
| Value | Count | Frequency (%) |
| 99999 | 34493 |
Length
Category Frequency Plot
| Value | Count | Frequency (%) |
| 99999 | 34493 |
Most occurring characters
| Value | Count | Frequency (%) |
| 9 | 172465 |
Most occurring categories
| Value | Count | Frequency (%) |
| Decimal Number | 172465 |
Most frequent character per category
Decimal Number
| Value | Count | Frequency (%) |
| 9 | 172465 |
Most occurring scripts
| Value | Count | Frequency (%) |
| Common | 172465 |
Most frequent character per script
Common
| Value | Count | Frequency (%) |
| 9 | 172465 |
Most occurring blocks
| Value | Count | Frequency (%) |
| ASCII | 172465 |
Most frequent character per block
ASCII
| Value | Count | Frequency (%) |
| 9 | 172465 |
| Distinct | 1 |
|---|---|
| Distinct (%) | < 0.1% |
| Missing | 0 |
| Missing (%) | 0.0% |
| Memory size | 2.0 MiB |
| 99999 |
|---|
Length
| Max length | 5 |
|---|---|
| Median length | 5 |
| Mean length | 5 |
| Min length | 5 |
Characters and Unicode
| Total characters | 172465 |
|---|---|
| Distinct characters | 1 |
| Distinct categories | 1 ? |
| Distinct scripts | 1 ? |
| Distinct blocks | 1 ? |
Unique
| Unique | 0 ? |
|---|---|
| Unique (%) | 0.0% |
Sample
| 1st row | 99999 |
|---|---|
| 2nd row | 99999 |
| 3rd row | 99999 |
| 4th row | 99999 |
| 5th row | 99999 |
Common Values
| Value | Count | Frequency (%) |
| 99999 | 34493 |
Length
Category Frequency Plot
| Value | Count | Frequency (%) |
| 99999 | 34493 |
Most occurring characters
| Value | Count | Frequency (%) |
| 9 | 172465 |
Most occurring categories
| Value | Count | Frequency (%) |
| Decimal Number | 172465 |
Most frequent character per category
Decimal Number
| Value | Count | Frequency (%) |
| 9 | 172465 |
Most occurring scripts
| Value | Count | Frequency (%) |
| Common | 172465 |
Most frequent character per script
Common
| Value | Count | Frequency (%) |
| 9 | 172465 |
Most occurring blocks
| Value | Count | Frequency (%) |
| ASCII | 172465 |
Most frequent character per block
ASCII
| Value | Count | Frequency (%) |
| 9 | 172465 |
| Distinct | 27316 |
|---|---|
| Distinct (%) | 79.2% |
| Missing | 0 |
| Missing (%) | 0.0% |
| Infinite | 0 |
| Infinite (%) | 0.0% |
| Mean | 3036916.702 |
| Minimum | 1001678 |
|---|---|
| Maximum | 3173059 |
| Zeros | 0 |
| Zeros (%) | 0.0% |
| Negative | 0 |
| Negative (%) | 0.0% |
| Memory size | 269.6 KiB |
Quantile statistics
| Minimum | 1001678 |
|---|---|
| 5-th percentile | 3003457 |
| Q1 | 3009494 |
| median | 3040235 |
| Q3 | 3076091 |
| 95-th percentile | 3129858.4 |
| Maximum | 3173059 |
| Range | 2171381 |
| Interquartile range (IQR) | 66597 |
Descriptive statistics
| Standard deviation | 146889.6846 |
|---|---|
| Coefficient of variation (CV) | 0.04836803213 |
| Kurtosis | 170.554896 |
| Mean | 3036916.702 |
| Median Absolute Deviation (MAD) | 31979 |
| Skewness | -12.56946917 |
| Sum | 1.047523678 × 1011 |
| Variance | 2.157657945 × 1010 |
| Monotonicity | Not monotonic |
| Value | Count | Frequency (%) |
| 3004670 | 6 | < 0.1% |
| 3007953 | 6 | < 0.1% |
| 3004764 | 6 | < 0.1% |
| 3007923 | 6 | < 0.1% |
| 3007934 | 6 | < 0.1% |
| 3004772 | 6 | < 0.1% |
| 3007889 | 6 | < 0.1% |
| 3007894 | 6 | < 0.1% |
| 3007900 | 6 | < 0.1% |
| 3007924 | 6 | < 0.1% |
| Other values (27306) | 34433 |
| Value | Count | Frequency (%) |
| 1001678 | 1 | |
| 1002657 | 1 | |
| 1003404 | 1 | |
| 1003693 | 1 | |
| 1003806 | 1 | |
| 1004014 | 1 | |
| 1005652 | 1 | |
| 1005945 | 1 | |
| 1006025 | 1 | |
| 1006179 | 1 |
| Value | Count | Frequency (%) |
| 3173059 | 1 | |
| 3173056 | 1 | |
| 3172855 | 1 | |
| 3172830 | 1 | |
| 3172803 | 1 | |
| 3171951 | 1 | |
| 3171790 | 1 | |
| 3170723 | 1 | |
| 3169512 | 1 | |
| 3169510 | 1 |
| Distinct | 10 |
|---|---|
| Distinct (%) | < 0.1% |
| Missing | 0 |
| Missing (%) | 0.0% |
| Memory size | 2.1 MiB |
| 03-2018 | |
|---|---|
| 02-2018 | |
| 02-2019 | |
| 01-2019 | |
| 03-2020 | |
| Other values (5) |
Length
| Max length | 7 |
|---|---|
| Median length | 7 |
| Mean length | 7 |
| Min length | 7 |
Characters and Unicode
| Total characters | 241451 |
|---|---|
| Distinct characters | 7 |
| Distinct categories | 2 ? |
| Distinct scripts | 1 ? |
| Distinct blocks | 1 ? |
Unique
| Unique | 0 ? |
|---|---|
| Unique (%) | 0.0% |
Sample
| 1st row | 01-2018 |
|---|---|
| 2nd row | 01-2018 |
| 3rd row | 01-2018 |
| 4th row | 01-2018 |
| 5th row | 01-2018 |
Common Values
| Value | Count | Frequency (%) |
| 03-2018 | 5568 | |
| 02-2018 | 5322 | |
| 02-2019 | 4876 | |
| 01-2019 | 4705 | |
| 03-2020 | 4148 | |
| 01-2018 | 4044 | |
| 02-2021 | 3829 | |
| 01-2021 | 1972 | 5.7% |
| 03-2019 | 22 | 0.1% |
| 02-2020 | 7 | < 0.1% |
Length
Category Frequency Plot
| Value | Count | Frequency (%) |
| 03-2018 | 5568 | |
| 02-2018 | 5322 | |
| 02-2019 | 4876 | |
| 01-2019 | 4705 | |
| 03-2020 | 4148 | |
| 01-2018 | 4044 | |
| 02-2021 | 3829 | |
| 01-2021 | 1972 | 5.7% |
| 03-2019 | 22 | 0.1% |
| 02-2020 | 7 | < 0.1% |
Most occurring characters
| Value | Count | Frequency (%) |
| 0 | 73141 | |
| 2 | 58483 | |
| 1 | 41059 | |
| - | 34493 | |
| 8 | 14934 | 6.2% |
| 3 | 9738 | 4.0% |
| 9 | 9603 | 4.0% |
Most occurring categories
| Value | Count | Frequency (%) |
| Decimal Number | 206958 | |
| Dash Punctuation | 34493 | 14.3% |
Most frequent character per category
Decimal Number
| Value | Count | Frequency (%) |
| 0 | 73141 | |
| 2 | 58483 | |
| 1 | 41059 | |
| 8 | 14934 | 7.2% |
| 3 | 9738 | 4.7% |
| 9 | 9603 | 4.6% |
Dash Punctuation
| Value | Count | Frequency (%) |
| - | 34493 |
Most occurring scripts
| Value | Count | Frequency (%) |
| Common | 241451 |
Most frequent character per script
Common
| Value | Count | Frequency (%) |
| 0 | 73141 | |
| 2 | 58483 | |
| 1 | 41059 | |
| - | 34493 | |
| 8 | 14934 | 6.2% |
| 3 | 9738 | 4.0% |
| 9 | 9603 | 4.0% |
Most occurring blocks
| Value | Count | Frequency (%) |
| ASCII | 241451 |
Most frequent character per block
ASCII
| Value | Count | Frequency (%) |
| 0 | 73141 | |
| 2 | 58483 | |
| 1 | 41059 | |
| - | 34493 | |
| 8 | 14934 | 6.2% |
| 3 | 9738 | 4.0% |
| 9 | 9603 | 4.0% |
| Distinct | 2 |
|---|---|
| Distinct (%) | < 0.1% |
| Missing | 0 |
| Missing (%) | 0.0% |
| Memory size | 1.9 MiB |
| 1 | |
|---|---|
| 0 |
Length
| Max length | 1 |
|---|---|
| Median length | 1 |
| Mean length | 1 |
| Min length | 1 |
Characters and Unicode
| Total characters | 34493 |
|---|---|
| Distinct characters | 2 |
| Distinct categories | 1 ? |
| Distinct scripts | 1 ? |
| Distinct blocks | 1 ? |
Unique
| Unique | 0 ? |
|---|---|
| Unique (%) | 0.0% |
Sample
| 1st row | 1 |
|---|---|
| 2nd row | 0 |
| 3rd row | 0 |
| 4th row | 0 |
| 5th row | 1 |
Common Values
| Value | Count | Frequency (%) |
| 1 | 24191 | |
| 0 | 10302 |
Length
Category Frequency Plot
| Value | Count | Frequency (%) |
| 1 | 24191 | |
| 0 | 10302 |
Most occurring characters
| Value | Count | Frequency (%) |
| 1 | 24191 | |
| 0 | 10302 |
Most occurring categories
| Value | Count | Frequency (%) |
| Decimal Number | 34493 |
Most frequent character per category
Decimal Number
| Value | Count | Frequency (%) |
| 1 | 24191 | |
| 0 | 10302 |
Most occurring scripts
| Value | Count | Frequency (%) |
| Common | 34493 |
Most frequent character per script
Common
| Value | Count | Frequency (%) |
| 1 | 24191 | |
| 0 | 10302 |
Most occurring blocks
| Value | Count | Frequency (%) |
| ASCII | 34493 |
Most frequent character per block
ASCII
| Value | Count | Frequency (%) |
| 1 | 24191 | |
| 0 | 10302 |
| Distinct | 10 |
|---|---|
| Distinct (%) | < 0.1% |
| Missing | 1130 |
| Missing (%) | 3.3% |
| Infinite | 0 |
| Infinite (%) | 0.0% |
| Mean | 3.104037407 |
| Minimum | 1 |
|---|---|
| Maximum | 16 |
| Zeros | 0 |
| Zeros (%) | 0.0% |
| Negative | 0 |
| Negative (%) | 0.0% |
| Memory size | 269.6 KiB |
Quantile statistics
| Minimum | 1 |
|---|---|
| 5-th percentile | 1 |
| Q1 | 1 |
| median | 2 |
| Q3 | 5 |
| 95-th percentile | 14 |
| Maximum | 16 |
| Range | 15 |
| Interquartile range (IQR) | 4 |
Descriptive statistics
| Standard deviation | 3.275958966 |
|---|---|
| Coefficient of variation (CV) | 1.055386433 |
| Kurtosis | 6.498626545 |
| Mean | 3.104037407 |
| Median Absolute Deviation (MAD) | 1 |
| Skewness | 2.502886697 |
| Sum | 103560 |
| Variance | 10.73190714 |
| Monotonicity | Not monotonic |
| Value | Count | Frequency (%) |
| 1 | 14608 | |
| 5 | 7479 | |
| 2 | 6060 | |
| 3 | 2301 | 6.7% |
| 14 | 1035 | 3.0% |
| 16 | 772 | 2.2% |
| 4 | 747 | 2.2% |
| 8 | 263 | 0.8% |
| 6 | 86 | 0.2% |
| 7 | 12 | < 0.1% |
| (Missing) | 1130 | 3.3% |
| Value | Count | Frequency (%) |
| 1 | 14608 | |
| 2 | 6060 | |
| 3 | 2301 | 6.7% |
| 4 | 747 | 2.2% |
| 5 | 7479 | |
| 6 | 86 | 0.2% |
| 7 | 12 | < 0.1% |
| 8 | 263 | 0.8% |
| 14 | 1035 | 3.0% |
| 16 | 772 | 2.2% |
| Value | Count | Frequency (%) |
| 16 | 772 | 2.2% |
| 14 | 1035 | 3.0% |
| 8 | 263 | 0.8% |
| 7 | 12 | < 0.1% |
| 6 | 86 | 0.2% |
| 5 | 7479 | |
| 4 | 747 | 2.2% |
| 3 | 2301 | 6.7% |
| 2 | 6060 | |
| 1 | 14608 |
total_siniestros
Real number (ℝ≥0)
HIGH CORRELATIONHIGH CORRELATIONHIGH CORRELATIONHIGH CORRELATIONMISSING| Distinct | 73 |
|---|---|
| Distinct (%) | 0.5% |
| Missing | 18691 |
| Missing (%) | 54.2% |
| Infinite | 0 |
| Infinite (%) | 0.0% |
| Mean | 1640.038286 |
| Minimum | 1 |
|---|---|
| Maximum | 3466 |
| Zeros | 0 |
| Zeros (%) | 0.0% |
| Negative | 0 |
| Negative (%) | 0.0% |
| Memory size | 269.6 KiB |
Quantile statistics
| Minimum | 1 |
|---|---|
| 5-th percentile | 1 |
| Q1 | 2 |
| median | 704 |
| Q3 | 3466 |
| 95-th percentile | 3466 |
| Maximum | 3466 |
| Range | 3465 |
| Interquartile range (IQR) | 3464 |
Descriptive statistics
| Standard deviation | 1683.612314 |
|---|---|
| Coefficient of variation (CV) | 1.026568909 |
| Kurtosis | -1.950909277 |
| Mean | 1640.038286 |
| Median Absolute Deviation (MAD) | 703 |
| Skewness | 0.1456458098 |
| Sum | 25915885 |
| Variance | 2834550.425 |
| Monotonicity | Not monotonic |
| Value | Count | Frequency (%) |
| 3466 | 7219 | 20.9% |
| 1 | 3738 | 10.8% |
| 704 | 1035 | 3.0% |
| 2 | 1012 | 2.9% |
| 136 | 772 | 2.2% |
| 3 | 429 | 1.2% |
| 4 | 278 | 0.8% |
| 5 | 262 | 0.8% |
| 92 | 207 | 0.6% |
| 7 | 168 | 0.5% |
| Other values (63) | 682 | 2.0% |
| (Missing) | 18691 |
| Value | Count | Frequency (%) |
| 1 | 3738 | |
| 2 | 1012 | 2.9% |
| 3 | 429 | 1.2% |
| 4 | 278 | 0.8% |
| 5 | 262 | 0.8% |
| 6 | 85 | 0.2% |
| 7 | 168 | 0.5% |
| 8 | 28 | 0.1% |
| 9 | 57 | 0.2% |
| 10 | 64 | 0.2% |
| Value | Count | Frequency (%) |
| 3466 | 7219 | |
| 2972 | 4 | < 0.1% |
| 1311 | 1 | < 0.1% |
| 770 | 1 | < 0.1% |
| 704 | 1035 | 3.0% |
| 543 | 5 | < 0.1% |
| 215 | 1 | < 0.1% |
| 179 | 1 | < 0.1% |
| 145 | 3 | < 0.1% |
| 140 | 1 | < 0.1% |
total_pagado_smmlv
Real number (ℝ≥0)
HIGH CORRELATIONHIGH CORRELATIONHIGH CORRELATIONHIGH CORRELATIONMISSINGZEROS| Distinct | 2308 |
|---|---|
| Distinct (%) | 14.6% |
| Missing | 18691 |
| Missing (%) | 54.2% |
| Infinite | 0 |
| Infinite (%) | 0.0% |
| Mean | 11868.21025 |
| Minimum | 0 |
|---|---|
| Maximum | 64793.74852 |
| Zeros | 1697 |
| Zeros (%) | 4.9% |
| Negative | 0 |
| Negative (%) | 0.0% |
| Memory size | 269.6 KiB |
Quantile statistics
| Minimum | 0 |
|---|---|
| 5-th percentile | 0 |
| Q1 | 10.99240408 |
| median | 5779.809377 |
| Q3 | 24921.89139 |
| 95-th percentile | 24921.89139 |
| Maximum | 64793.74852 |
| Range | 64793.74852 |
| Interquartile range (IQR) | 24910.89899 |
Descriptive statistics
| Standard deviation | 12093.24543 |
|---|---|
| Coefficient of variation (CV) | 1.018961172 |
| Kurtosis | -1.863889317 |
| Mean | 11868.21025 |
| Median Absolute Deviation (MAD) | 5779.809377 |
| Skewness | 0.155327507 |
| Sum | 187541458.4 |
| Variance | 146246585 |
| Monotonicity | Not monotonic |
| Value | Count | Frequency (%) |
| 24921.89139 | 7219 | 20.9% |
| 0 | 1697 | 4.9% |
| 5779.809377 | 1035 | 3.0% |
| 1308.359896 | 772 | 2.2% |
| 506.8921899 | 207 | 0.6% |
| 41.55167503 | 87 | 0.3% |
| 133.4554683 | 71 | 0.2% |
| 205.1638361 | 54 | 0.2% |
| 794.1729883 | 32 | 0.1% |
| 289.5339288 | 29 | 0.1% |
| Other values (2298) | 4599 | 13.3% |
| (Missing) | 18691 |
| Value | Count | Frequency (%) |
| 0 | 1697 | |
| 0.01143934598 | 2 | < 0.1% |
| 0.02341413734 | 1 | < 0.1% |
| 0.05839231033 | 6 | < 0.1% |
| 0.06651725121 | 1 | < 0.1% |
| 0.068615991 | 2 | < 0.1% |
| 0.07482544489 | 4 | < 0.1% |
| 0.0807227466 | 9 | < 0.1% |
| 0.09830500664 | 2 | < 0.1% |
| 0.1138898415 | 1 | < 0.1% |
| Value | Count | Frequency (%) |
| 64793.74852 | 4 | < 0.1% |
| 24921.89139 | 7219 | |
| 5779.809377 | 1035 | 3.0% |
| 3629.20443 | 2 | < 0.1% |
| 2962.748964 | 5 | < 0.1% |
| 2501.817204 | 2 | < 0.1% |
| 1308.359896 | 772 | 2.2% |
| 1295.661733 | 1 | < 0.1% |
| 1194.044419 | 2 | < 0.1% |
| 1124.784281 | 3 | < 0.1% |
anios_ultimo_siniestro
Real number (ℝ≥0)
HIGH CORRELATIONHIGH CORRELATIONHIGH CORRELATIONHIGH CORRELATIONMISSING| Distinct | 1140 |
|---|---|
| Distinct (%) | 7.2% |
| Missing | 18691 |
| Missing (%) | 54.2% |
| Infinite | 0 |
| Infinite (%) | 0.0% |
| Mean | 0.66014862 |
| Minimum | 0.002739726027 |
|---|---|
| Maximum | 10.69863014 |
| Zeros | 0 |
| Zeros (%) | 0.0% |
| Negative | 0 |
| Negative (%) | 0.0% |
| Memory size | 269.6 KiB |
Quantile statistics
| Minimum | 0.002739726027 |
|---|---|
| 5-th percentile | 0.002739726027 |
| Q1 | 0.002739726027 |
| median | 0.008219178082 |
| Q3 | 1.238356164 |
| 95-th percentile | 2.764383562 |
| Maximum | 10.69863014 |
| Range | 10.69589041 |
| Interquartile range (IQR) | 1.235616438 |
Descriptive statistics
| Standard deviation | 1.042983795 |
|---|---|
| Coefficient of variation (CV) | 1.579922708 |
| Kurtosis | 5.679649006 |
| Mean | 0.66014862 |
| Median Absolute Deviation (MAD) | 0.005479452055 |
| Skewness | 1.884821477 |
| Sum | 10431.66849 |
| Variance | 1.087815197 |
| Monotonicity | Not monotonic |
| Value | Count | Frequency (%) |
| 0.002739726027 | 7223 | 20.9% |
| 0.0602739726 | 1044 | 3.0% |
| 0.008219178082 | 798 | 2.3% |
| 0.04383561644 | 209 | 0.6% |
| 0.4328767123 | 90 | 0.3% |
| 0.08767123288 | 90 | 0.3% |
| 0.1534246575 | 66 | 0.2% |
| 0.07671232877 | 46 | 0.1% |
| 1.684931507 | 32 | 0.1% |
| 1.449315068 | 32 | 0.1% |
| Other values (1130) | 6172 | 17.9% |
| (Missing) | 18691 |
| Value | Count | Frequency (%) |
| 0.002739726027 | 7223 | |
| 0.005479452055 | 13 | < 0.1% |
| 0.008219178082 | 798 | 2.3% |
| 0.01095890411 | 13 | < 0.1% |
| 0.01369863014 | 13 | < 0.1% |
| 0.01643835616 | 11 | < 0.1% |
| 0.01917808219 | 4 | < 0.1% |
| 0.02465753425 | 9 | < 0.1% |
| 0.02739726027 | 2 | < 0.1% |
| 0.0301369863 | 8 | < 0.1% |
| Value | Count | Frequency (%) |
| 10.69863014 | 2 | < 0.1% |
| 10.00273973 | 6 | |
| 9.095890411 | 1 | < 0.1% |
| 7.923287671 | 1 | < 0.1% |
| 7.509589041 | 2 | < 0.1% |
| 7.282191781 | 1 | < 0.1% |
| 7.082191781 | 2 | < 0.1% |
| 6.97260274 | 1 | < 0.1% |
| 6.81369863 | 1 | < 0.1% |
| 6.668493151 | 2 | < 0.1% |
| Distinct | 3500 |
|---|---|
| Distinct (%) | 17.4% |
| Missing | 14407 |
| Missing (%) | 41.8% |
| Infinite | 0 |
| Infinite (%) | 0.0% |
| Mean | 426319534.1 |
| Minimum | 0 |
|---|---|
| Maximum | 1 × 1012 |
| Zeros | 20 |
| Zeros (%) | 0.1% |
| Negative | 0 |
| Negative (%) | 0.0% |
| Memory size | 269.6 KiB |
Quantile statistics
| Minimum | 0 |
|---|---|
| 5-th percentile | 21250000 |
| Q1 | 60000000 |
| median | 120000000 |
| Q3 | 250000000 |
| 95-th percentile | 994554000 |
| Maximum | 1 × 1012 |
| Range | 1 × 1012 |
| Interquartile range (IQR) | 190000000 |
Descriptive statistics
| Standard deviation | 1.009835822 × 1010 |
|---|---|
| Coefficient of variation (CV) | 23.68729887 |
| Kurtosis | 9560.011934 |
| Mean | 426319534.1 |
| Median Absolute Deviation (MAD) | 79053000 |
| Skewness | 96.7181334 |
| Sum | 8.563054163 × 1012 |
| Variance | 1.019768387 × 1020 |
| Monotonicity | Not monotonic |
| Value | Count | Frequency (%) |
| 100000000 | 1003 | 2.9% |
| 80000000 | 753 | 2.2% |
| 150000000 | 711 | 2.1% |
| 200000000 | 686 | 2.0% |
| 50000000 | 640 | 1.9% |
| 120000000 | 557 | 1.6% |
| 60000000 | 544 | 1.6% |
| 40000000 | 482 | 1.4% |
| 30000000 | 443 | 1.3% |
| 90000000 | 417 | 1.2% |
| Other values (3490) | 13850 | |
| (Missing) | 14407 |
| Value | Count | Frequency (%) |
| 0 | 20 | 0.1% |
| 1 | 66 | |
| 2 | 3 | < 0.1% |
| 20 | 2 | < 0.1% |
| 40 | 3 | < 0.1% |
| 50 | 1 | < 0.1% |
| 80 | 1 | < 0.1% |
| 100 | 3 | < 0.1% |
| 104 | 1 | < 0.1% |
| 350 | 2 | < 0.1% |
| Value | Count | Frequency (%) |
| 1 × 1012 | 2 | |
| 1 × 1011 | 2 | |
| 5.835 × 1010 | 1 | < 0.1% |
| 5.43154931 × 1010 | 1 | < 0.1% |
| 4.479 × 1010 | 1 | < 0.1% |
| 4.0078653 × 1010 | 4 | |
| 2.8125029 × 1010 | 2 | |
| 2.43 × 1010 | 1 | < 0.1% |
| 2.0615603 × 1010 | 1 | < 0.1% |
| 2.0178092 × 1010 | 1 | < 0.1% |
AnnualRevenue
Real number (ℝ≥0)
HIGH CORRELATIONHIGH CORRELATIONHIGH CORRELATIONHIGH CORRELATIONMISSINGSKEWED| Distinct | 3424 |
|---|---|
| Distinct (%) | 17.0% |
| Missing | 14407 |
| Missing (%) | 41.8% |
| Infinite | 0 |
| Infinite (%) | 0.0% |
| Mean | 240635915.3 |
| Minimum | 0 |
|---|---|
| Maximum | 8.63 × 1010 |
| Zeros | 6 |
| Zeros (%) | < 0.1% |
| Negative | 0 |
| Negative (%) | 0.0% |
| Memory size | 269.6 KiB |
Quantile statistics
| Minimum | 0 |
|---|---|
| 5-th percentile | 8600000 |
| Q1 | 26400000 |
| median | 45000000 |
| Q3 | 84000000 |
| 95-th percentile | 586071843.2 |
| Maximum | 8.63 × 1010 |
| Range | 8.63 × 1010 |
| Interquartile range (IQR) | 57600000 |
Descriptive statistics
| Standard deviation | 1545629592 |
|---|---|
| Coefficient of variation (CV) | 6.423104338 |
| Kurtosis | 825.72905 |
| Mean | 240635915.3 |
| Median Absolute Deviation (MAD) | 22000000 |
| Skewness | 22.54403697 |
| Sum | 4.833412995 × 1012 |
| Variance | 2.388970835 × 1018 |
| Monotonicity | Not monotonic |
| Value | Count | Frequency (%) |
| 36000000 | 1089 | 3.2% |
| 60000000 | 845 | 2.4% |
| 24000000 | 770 | 2.2% |
| 30000000 | 767 | 2.2% |
| 48000000 | 630 | 1.8% |
| 18000000 | 442 | 1.3% |
| 50000000 | 393 | 1.1% |
| 40000000 | 374 | 1.1% |
| 12000000 | 330 | 1.0% |
| 42000000 | 315 | 0.9% |
| Other values (3414) | 14131 | |
| (Missing) | 14407 |
| Value | Count | Frequency (%) |
| 0 | 6 | < 0.1% |
| 1 | 27 | |
| 20 | 2 | < 0.1% |
| 52230 | 1 | < 0.1% |
| 250000 | 1 | < 0.1% |
| 350000 | 1 | < 0.1% |
| 500000 | 3 | < 0.1% |
| 600000 | 1 | < 0.1% |
| 700000 | 1 | < 0.1% |
| 800000 | 12 |
| Value | Count | Frequency (%) |
| 8.63 × 1010 | 1 | < 0.1% |
| 6.6728 × 1010 | 1 | < 0.1% |
| 4.1610143 × 1010 | 2 | < 0.1% |
| 3.6110425 × 1010 | 5 | |
| 2.576590619 × 1010 | 2 | < 0.1% |
| 2.469016564 × 1010 | 3 | |
| 2.3626255 × 1010 | 2 | < 0.1% |
| 2.3246 × 1010 | 1 | < 0.1% |
| 2.2159396 × 1010 | 2 | < 0.1% |
| 2.1401724 × 1010 | 2 | < 0.1% |
| Distinct | 9 |
|---|---|
| Distinct (%) | 45.0% |
| Missing | 34473 |
| Missing (%) | 99.9% |
| Infinite | 0 |
| Infinite (%) | 0.0% |
| Mean | 3422.05 |
| Minimum | 0 |
|---|---|
| Maximum | 21605 |
| Zeros | 9 |
| Zeros (%) | < 0.1% |
| Negative | 0 |
| Negative (%) | 0.0% |
| Memory size | 269.6 KiB |
Quantile statistics
| Minimum | 0 |
|---|---|
| 5-th percentile | 0 |
| Q1 | 0 |
| median | 3 |
| Q3 | 3000 |
| 95-th percentile | 21605 |
| Maximum | 21605 |
| Range | 21605 |
| Interquartile range (IQR) | 3000 |
Descriptive statistics
| Standard deviation | 6716.982315 |
|---|---|
| Coefficient of variation (CV) | 1.962853352 |
| Kurtosis | 4.346263153 |
| Mean | 3422.05 |
| Median Absolute Deviation (MAD) | 3 |
| Skewness | 2.280328803 |
| Sum | 68441 |
| Variance | 45117851.42 |
| Monotonicity | Not monotonic |
| Value | Count | Frequency (%) |
| 0 | 9 | < 0.1% |
| 3000 | 3 | < 0.1% |
| 21605 | 2 | < 0.1% |
| 10000 | 1 | < 0.1% |
| 5525 | 1 | < 0.1% |
| 600 | 1 | < 0.1% |
| 5 | 1 | < 0.1% |
| 1 | 1 | < 0.1% |
| 100 | 1 | < 0.1% |
| (Missing) | 34473 |
| Value | Count | Frequency (%) |
| 0 | 9 | |
| 1 | 1 | < 0.1% |
| 5 | 1 | < 0.1% |
| 100 | 1 | < 0.1% |
| 600 | 1 | < 0.1% |
| 3000 | 3 | < 0.1% |
| 5525 | 1 | < 0.1% |
| 10000 | 1 | < 0.1% |
| 21605 | 2 | < 0.1% |
| Value | Count | Frequency (%) |
| 21605 | 2 | < 0.1% |
| 10000 | 1 | < 0.1% |
| 5525 | 1 | < 0.1% |
| 3000 | 3 | < 0.1% |
| 600 | 1 | < 0.1% |
| 100 | 1 | < 0.1% |
| 5 | 1 | < 0.1% |
| 1 | 1 | < 0.1% |
| 0 | 9 |
| Distinct | 217 |
|---|---|
| Distinct (%) | 1.1% |
| Missing | 15501 |
| Missing (%) | 44.9% |
| Infinite | 0 |
| Infinite (%) | 0.0% |
| Mean | 2248604.142 |
| Minimum | 0 |
|---|---|
| Maximum | 8400000000 |
| Zeros | 18238 |
| Zeros (%) | 52.9% |
| Negative | 0 |
| Negative (%) | 0.0% |
| Memory size | 269.6 KiB |
Quantile statistics
| Minimum | 0 |
|---|---|
| 5-th percentile | 0 |
| Q1 | 0 |
| median | 0 |
| Q3 | 0 |
| 95-th percentile | 0 |
| Maximum | 8400000000 |
| Range | 8400000000 |
| Interquartile range (IQR) | 0 |
Descriptive statistics
| Standard deviation | 69064469.41 |
|---|---|
| Coefficient of variation (CV) | 30.71437437 |
| Kurtosis | 11607.31434 |
| Mean | 2248604.142 |
| Median Absolute Deviation (MAD) | 0 |
| Skewness | 98.99998221 |
| Sum | 4.270548986 × 1010 |
| Variance | 4.769900936 × 1015 |
| Monotonicity | Not monotonic |
| Value | Count | Frequency (%) |
| 0 | 18238 | |
| 12000000 | 52 | 0.2% |
| 10000000 | 31 | 0.1% |
| 24000000 | 29 | 0.1% |
| 30000000 | 23 | 0.1% |
| 6000000 | 22 | 0.1% |
| 20000000 | 19 | 0.1% |
| 7200000 | 17 | < 0.1% |
| 18000000 | 17 | < 0.1% |
| 15000000 | 16 | < 0.1% |
| Other values (207) | 528 | 1.5% |
| (Missing) | 15501 |
| Value | Count | Frequency (%) |
| 0 | 18238 | |
| 183000 | 1 | < 0.1% |
| 200000 | 4 | < 0.1% |
| 228000 | 1 | < 0.1% |
| 239000 | 1 | < 0.1% |
| 244000 | 1 | < 0.1% |
| 274000 | 7 | < 0.1% |
| 300000 | 2 | < 0.1% |
| 378000 | 2 | < 0.1% |
| 378840 | 1 | < 0.1% |
| Value | Count | Frequency (%) |
| 8400000000 | 1 | < 0.1% |
| 1664801000 | 5 | |
| 936054000 | 1 | < 0.1% |
| 928737000 | 2 | < 0.1% |
| 862423500 | 2 | < 0.1% |
| 436838000 | 1 | < 0.1% |
| 398188968 | 1 | < 0.1% |
| 268346000 | 3 | |
| 250423000 | 2 | < 0.1% |
| 233846000 | 2 | < 0.1% |
EgresosAnuales__c
Real number (ℝ≥0)
HIGH CORRELATIONHIGH CORRELATIONHIGH CORRELATIONHIGH CORRELATIONMISSING| Distinct | 2698 |
|---|---|
| Distinct (%) | 13.4% |
| Missing | 14407 |
| Missing (%) | 41.8% |
| Infinite | 0 |
| Infinite (%) | 0.0% |
| Mean | 162201749.3 |
| Minimum | 0 |
|---|---|
| Maximum | 3.6967344 × 1010 |
| Zeros | 10 |
| Zeros (%) | < 0.1% |
| Negative | 0 |
| Negative (%) | 0.0% |
| Memory size | 269.6 KiB |
Quantile statistics
| Minimum | 0 |
|---|---|
| 5-th percentile | 3000000 |
| Q1 | 12300000 |
| median | 24000000 |
| Q3 | 50000000 |
| 95-th percentile | 441252500 |
| Maximum | 3.6967344 × 1010 |
| Range | 3.6967344 × 1010 |
| Interquartile range (IQR) | 37700000 |
Descriptive statistics
| Standard deviation | 1034423361 |
|---|---|
| Coefficient of variation (CV) | 6.377387207 |
| Kurtosis | 457.3774663 |
| Mean | 162201749.3 |
| Median Absolute Deviation (MAD) | 14000000 |
| Skewness | 18.32164113 |
| Sum | 3.257984337 × 1012 |
| Variance | 1.07003169 × 1018 |
| Monotonicity | Not monotonic |
| Value | Count | Frequency (%) |
| 12000000 | 1056 | 3.1% |
| 30000000 | 918 | 2.7% |
| 24000000 | 860 | 2.5% |
| 18000000 | 813 | 2.4% |
| 20000000 | 797 | 2.3% |
| 36000000 | 493 | 1.4% |
| 15000000 | 468 | 1.4% |
| 10000000 | 451 | 1.3% |
| 40000000 | 428 | 1.2% |
| 25000000 | 393 | 1.1% |
| Other values (2688) | 13409 | |
| (Missing) | 14407 |
| Value | Count | Frequency (%) |
| 0 | 10 | < 0.1% |
| 1 | 114 | |
| 10 | 8 | < 0.1% |
| 18 | 1 | < 0.1% |
| 100 | 1 | < 0.1% |
| 204 | 2 | < 0.1% |
| 20000 | 1 | < 0.1% |
| 70000 | 1 | < 0.1% |
| 72000 | 3 | < 0.1% |
| 87699 | 1 | < 0.1% |
| Value | Count | Frequency (%) |
| 3.6967344 × 1010 | 2 | < 0.1% |
| 3.0868341 × 1010 | 5 | |
| 2.166849912 × 1010 | 2 | < 0.1% |
| 2.1322738 × 1010 | 2 | < 0.1% |
| 1.9746108 × 1010 | 2 | < 0.1% |
| 1.923885007 × 1010 | 3 | |
| 1.8035021 × 1010 | 1 | < 0.1% |
| 1.629516502 × 1010 | 2 | < 0.1% |
| 1.4868 × 1010 | 2 | < 0.1% |
| 1.2720892 × 1010 | 1 | < 0.1% |
| Distinct | 8 |
|---|---|
| Distinct (%) | < 0.1% |
| Missing | 14147 |
| Missing (%) | 41.0% |
| Memory size | 1.7 MiB |
| SOLTERO | |
|---|---|
| CASADO | |
| OTRO | |
| UNIDO | 295 |
| VIUDO | 73 |
| Other values (3) | 122 |
Length
| Max length | 10 |
|---|---|
| Median length | 8 |
| Mean length | 6.32709132 |
| Min length | 3 |
Characters and Unicode
| Total characters | 128731 |
|---|---|
| Distinct characters | 15 |
| Distinct categories | 2 ? |
| Distinct scripts | 2 ? |
| Distinct blocks | 1 ? |
Unique
| Unique | 0 ? |
|---|---|
| Unique (%) | 0.0% |
Sample
| 1st row | CASADO |
|---|---|
| 2nd row | CASADO |
| 3rd row | OTRO |
| 4th row | CASADO |
| 5th row | SOLTERO |
Common Values
| Value | Count | Frequency (%) |
| SOLTERO | 9638 | |
| CASADO | 8774 | |
| OTRO | 1444 | 4.2% |
| UNIDO | 295 | 0.9% |
| VIUDO | 73 | 0.2% |
| SEPARADO | 69 | 0.2% |
| DIVORCIADO | 42 | 0.1% |
| N A | 11 | < 0.1% |
| (Missing) | 14147 |
Length
Category Frequency Plot
| Value | Count | Frequency (%) |
| soltero | 9638 | |
| casado | 8774 | |
| otro | 1444 | 7.1% |
| unido | 295 | 1.4% |
| viudo | 73 | 0.4% |
| separado | 69 | 0.3% |
| divorciado | 42 | 0.2% |
| n | 11 | 0.1% |
| a | 11 | 0.1% |
Most occurring characters
| Value | Count | Frequency (%) |
| O | 31459 | |
| S | 18481 | |
| A | 17739 | |
| R | 11193 | 8.7% |
| T | 11082 | 8.6% |
| E | 9707 | 7.5% |
| L | 9638 | 7.5% |
| D | 9295 | 7.2% |
| C | 8816 | 6.8% |
| I | 452 | 0.4% |
| Other values (5) | 869 | 0.7% |
Most occurring categories
| Value | Count | Frequency (%) |
| Uppercase Letter | 128720 | |
| Space Separator | 11 | < 0.1% |
Most frequent character per category
Uppercase Letter
| Value | Count | Frequency (%) |
| O | 31459 | |
| S | 18481 | |
| A | 17739 | |
| R | 11193 | 8.7% |
| T | 11082 | 8.6% |
| E | 9707 | 7.5% |
| L | 9638 | 7.5% |
| D | 9295 | 7.2% |
| C | 8816 | 6.8% |
| I | 452 | 0.4% |
| Other values (4) | 858 | 0.7% |
Space Separator
| Value | Count | Frequency (%) |
| 11 |
Most occurring scripts
| Value | Count | Frequency (%) |
| Latin | 128720 | |
| Common | 11 | < 0.1% |
Most frequent character per script
Latin
| Value | Count | Frequency (%) |
| O | 31459 | |
| S | 18481 | |
| A | 17739 | |
| R | 11193 | 8.7% |
| T | 11082 | 8.6% |
| E | 9707 | 7.5% |
| L | 9638 | 7.5% |
| D | 9295 | 7.2% |
| C | 8816 | 6.8% |
| I | 452 | 0.4% |
| Other values (4) | 858 | 0.7% |
Common
| Value | Count | Frequency (%) |
| 11 |
Most occurring blocks
| Value | Count | Frequency (%) |
| ASCII | 128731 |
Most frequent character per block
ASCII
| Value | Count | Frequency (%) |
| O | 31459 | |
| S | 18481 | |
| A | 17739 | |
| R | 11193 | 8.7% |
| T | 11082 | 8.6% |
| E | 9707 | 7.5% |
| L | 9638 | 7.5% |
| D | 9295 | 7.2% |
| C | 8816 | 6.8% |
| I | 452 | 0.4% |
| Other values (5) | 869 | 0.7% |
| Distinct | 3 |
|---|---|
| Distinct (%) | < 0.1% |
| Missing | 14147 |
| Missing (%) | 41.0% |
| Memory size | 1.7 MiB |
| MASCULINO | |
|---|---|
| FEMENINO | |
| N A | 8 |
Length
| Max length | 9 |
|---|---|
| Median length | 9 |
| Mean length | 8.755136145 |
| Min length | 3 |
Characters and Unicode
| Total characters | 178132 |
|---|---|
| Distinct characters | 12 |
| Distinct categories | 2 ? |
| Distinct scripts | 2 ? |
| Distinct blocks | 1 ? |
Unique
| Unique | 0 ? |
|---|---|
| Unique (%) | 0.0% |
Sample
| 1st row | MASCULINO |
|---|---|
| 2nd row | FEMENINO |
| 3rd row | FEMENINO |
| 4th row | MASCULINO |
| 5th row | MASCULINO |
Common Values
| Value | Count | Frequency (%) |
| MASCULINO | 15404 | |
| FEMENINO | 4934 | 14.3% |
| N A | 8 | < 0.1% |
| (Missing) | 14147 |
Length
Category Frequency Plot
| Value | Count | Frequency (%) |
| masculino | 15404 | |
| femenino | 4934 | 24.2% |
| n | 8 | < 0.1% |
| a | 8 | < 0.1% |
Most occurring characters
| Value | Count | Frequency (%) |
| N | 25280 | |
| M | 20338 | |
| I | 20338 | |
| O | 20338 | |
| A | 15412 | |
| S | 15404 | |
| C | 15404 | |
| U | 15404 | |
| L | 15404 | |
| E | 9868 | 5.5% |
| Other values (2) | 4942 | 2.8% |
Most occurring categories
| Value | Count | Frequency (%) |
| Uppercase Letter | 178124 | |
| Space Separator | 8 | < 0.1% |
Most frequent character per category
Uppercase Letter
| Value | Count | Frequency (%) |
| N | 25280 | |
| M | 20338 | |
| I | 20338 | |
| O | 20338 | |
| A | 15412 | |
| S | 15404 | |
| C | 15404 | |
| U | 15404 | |
| L | 15404 | |
| E | 9868 | 5.5% |
Space Separator
| Value | Count | Frequency (%) |
| 8 |
Most occurring scripts
| Value | Count | Frequency (%) |
| Latin | 178124 | |
| Common | 8 | < 0.1% |
Most frequent character per script
Latin
| Value | Count | Frequency (%) |
| N | 25280 | |
| M | 20338 | |
| I | 20338 | |
| O | 20338 | |
| A | 15412 | |
| S | 15404 | |
| C | 15404 | |
| U | 15404 | |
| L | 15404 | |
| E | 9868 | 5.5% |
Common
| Value | Count | Frequency (%) |
| 8 |
Most occurring blocks
| Value | Count | Frequency (%) |
| ASCII | 178132 |
Most frequent character per block
ASCII
| Value | Count | Frequency (%) |
| N | 25280 | |
| M | 20338 | |
| I | 20338 | |
| O | 20338 | |
| A | 15412 | |
| S | 15404 | |
| C | 15404 | |
| U | 15404 | |
| L | 15404 | |
| E | 9868 | 5.5% |
| Other values (2) | 4942 | 2.8% |
| Distinct | 22 |
|---|---|
| Distinct (%) | 0.1% |
| Missing | 14147 |
| Missing (%) | 41.0% |
| Memory size | 1.7 MiB |
| otras | |
|---|---|
| BOGOTÁ D.C. | 1514 |
| MEDELLIN | 727 |
| CALI | 556 |
| CARTAGENA | 179 |
| Other values (17) | 1537 |
Length
| Max length | 13 |
|---|---|
| Median length | 5 |
| Mean length | 5.807578885 |
| Min length | 4 |
Characters and Unicode
| Total characters | 118161 |
|---|---|
| Distinct characters | 31 |
| Distinct categories | 4 ? |
| Distinct scripts | 2 ? |
| Distinct blocks | 2 ? |
Unique
| Unique | 0 ? |
|---|---|
| Unique (%) | 0.0% |
Sample
| 1st row | otras |
|---|---|
| 2nd row | BOGOTÁ D.C. |
| 3rd row | otras |
| 4th row | BARRANQUILLA |
| 5th row | otras |
Common Values
| Value | Count | Frequency (%) |
| otras | 15833 | |
| BOGOTÁ D.C. | 1514 | 4.4% |
| MEDELLIN | 727 | 2.1% |
| CALI | 556 | 1.6% |
| CARTAGENA | 179 | 0.5% |
| VILLAVICENCIO | 173 | 0.5% |
| YOPAL | 172 | 0.5% |
| PASTO | 166 | 0.5% |
| BUCARAMANGA | 162 | 0.5% |
| MANIZALES | 129 | 0.4% |
| Other values (12) | 735 | 2.1% |
| (Missing) | 14147 |
Length
| Value | Count | Frequency (%) |
| otras | 15833 | |
| bogotá | 1514 | 6.9% |
| d.c | 1514 | 6.9% |
| medellin | 727 | 3.3% |
| cali | 556 | 2.5% |
| cartagena | 179 | 0.8% |
| villavicencio | 173 | 0.8% |
| yopal | 172 | 0.8% |
| pasto | 166 | 0.8% |
| bucaramanga | 162 | 0.7% |
| Other values (17) | 1003 | 4.6% |
Most occurring characters
| Value | Count | Frequency (%) |
| o | 15833 | |
| r | 15833 | |
| a | 15833 | |
| s | 15833 | |
| t | 15833 | |
| O | 3748 | 3.2% |
| A | 3621 | 3.1% |
| C | 3072 | 2.6% |
| . | 3028 | 2.6% |
| L | 2951 | 2.5% |
| Other values (21) | 22576 |
Most occurring categories
| Value | Count | Frequency (%) |
| Lowercase Letter | 79165 | |
| Uppercase Letter | 34315 | |
| Other Punctuation | 3028 | 2.6% |
| Space Separator | 1653 | 1.4% |
Most frequent character per category
Uppercase Letter
| Value | Count | Frequency (%) |
| O | 3748 | |
| A | 3621 | |
| C | 3072 | 9.0% |
| L | 2951 | 8.6% |
| I | 2458 | 7.2% |
| E | 2387 | 7.0% |
| D | 2371 | 6.9% |
| T | 2025 | 5.9% |
| G | 1957 | 5.7% |
| B | 1822 | 5.3% |
| Other values (14) | 7903 |
Lowercase Letter
| Value | Count | Frequency (%) |
| o | 15833 | |
| r | 15833 | |
| a | 15833 | |
| s | 15833 | |
| t | 15833 |
Other Punctuation
| Value | Count | Frequency (%) |
| . | 3028 |
Space Separator
| Value | Count | Frequency (%) |
| 1653 |
Most occurring scripts
| Value | Count | Frequency (%) |
| Latin | 113480 | |
| Common | 4681 | 4.0% |
Most frequent character per script
Latin
| Value | Count | Frequency (%) |
| o | 15833 | |
| r | 15833 | |
| a | 15833 | |
| s | 15833 | |
| t | 15833 | |
| O | 3748 | 3.3% |
| A | 3621 | 3.2% |
| C | 3072 | 2.7% |
| L | 2951 | 2.6% |
| I | 2458 | 2.2% |
| Other values (19) | 18465 |
Common
| Value | Count | Frequency (%) |
| . | 3028 | |
| 1653 |
Most occurring blocks
| Value | Count | Frequency (%) |
| ASCII | 116420 | |
| None | 1741 | 1.5% |
Most frequent character per block
ASCII
| Value | Count | Frequency (%) |
| o | 15833 | |
| r | 15833 | |
| a | 15833 | |
| s | 15833 | |
| t | 15833 | |
| O | 3748 | 3.2% |
| A | 3621 | 3.1% |
| C | 3072 | 2.6% |
| . | 3028 | 2.6% |
| L | 2951 | 2.5% |
| Other values (18) | 20835 |
None
| Value | Count | Frequency (%) |
| Á | 1584 | |
| Ú | 111 | 6.4% |
| É | 46 | 2.6% |
| Distinct | 9598 |
|---|---|
| Distinct (%) | 47.2% |
| Missing | 14178 |
| Missing (%) | 41.1% |
| Infinite | 0 |
| Infinite (%) | 0.0% |
| Mean | 49.10082151 |
| Minimum | 1.397260274 |
|---|---|
| Maximum | 122.5123288 |
| Zeros | 0 |
| Zeros (%) | 0.0% |
| Negative | 0 |
| Negative (%) | 0.0% |
| Memory size | 269.6 KiB |
Quantile statistics
| Minimum | 1.397260274 |
|---|---|
| 5-th percentile | 28.65616438 |
| Q1 | 38.85616438 |
| median | 48.17808219 |
| Q3 | 58.83013699 |
| 95-th percentile | 71.91041096 |
| Maximum | 122.5123288 |
| Range | 121.1150685 |
| Interquartile range (IQR) | 19.9739726 |
Descriptive statistics
| Standard deviation | 13.53019398 |
|---|---|
| Coefficient of variation (CV) | 0.2755594216 |
| Kurtosis | -0.04205794412 |
| Mean | 49.10082151 |
| Median Absolute Deviation (MAD) | 9.942465753 |
| Skewness | 0.2629557078 |
| Sum | 997483.189 |
| Variance | 183.0661491 |
| Monotonicity | Not monotonic |
| Value | Count | Frequency (%) |
| 46.69041096 | 80 | 0.2% |
| 47.51780822 | 77 | 0.2% |
| 42.46027397 | 38 | 0.1% |
| 43.68767123 | 22 | 0.1% |
| 41.58356164 | 21 | 0.1% |
| 36.50958904 | 20 | 0.1% |
| 60.55616438 | 19 | 0.1% |
| 47.69041096 | 16 | < 0.1% |
| 54.94246575 | 16 | < 0.1% |
| 71.5260274 | 15 | < 0.1% |
| Other values (9588) | 19991 | |
| (Missing) | 14178 |
| Value | Count | Frequency (%) |
| 1.397260274 | 1 | |
| 3.375342466 | 1 | |
| 3.408219178 | 1 | |
| 4.232876712 | 1 | |
| 4.257534247 | 1 | |
| 4.336986301 | 1 | |
| 4.350684932 | 2 | |
| 4.397260274 | 1 | |
| 4.430136986 | 2 | |
| 4.764383562 | 1 |
| Value | Count | Frequency (%) |
| 122.5123288 | 7 | |
| 104.9561644 | 2 | < 0.1% |
| 103.0739726 | 3 | |
| 100.0191781 | 1 | < 0.1% |
| 96.36438356 | 2 | < 0.1% |
| 94.30958904 | 2 | < 0.1% |
| 92.80547945 | 2 | < 0.1% |
| 92.49589041 | 1 | < 0.1% |
| 92.25479452 | 2 | < 0.1% |
| 91.08219178 | 2 | < 0.1% |
Spearman's ρ
The Spearman's rank correlation coefficient (ρ) is a measure of monotonic correlation between two variables, and is therefore better in catching nonlinear monotonic correlations than Pearson's r. It's value lies between -1 and +1, -1 indicating total negative monotonic correlation, 0 indicating no monotonic correlation and 1 indicating total positive monotonic correlation.To calculate ρ for two variables X and Y, one divides the covariance of the rank variables of X and Y by the product of their standard deviations.
Pearson's r
The Pearson's correlation coefficient (r) is a measure of linear correlation between two variables. It's value lies between -1 and +1, -1 indicating total negative linear correlation, 0 indicating no linear correlation and 1 indicating total positive linear correlation. Furthermore, r is invariant under separate changes in location and scale of the two variables, implying that for a linear function the angle to the x-axis does not affect r.To calculate r for two variables X and Y, one divides the covariance of X and Y by the product of their standard deviations.
Kendall's τ
Similarly to Spearman's rank correlation coefficient, the Kendall rank correlation coefficient (τ) measures ordinal association between two variables. It's value lies between -1 and +1, -1 indicating total negative correlation, 0 indicating no correlation and 1 indicating total positive correlation.To calculate τ for two variables X and Y, one determines the number of concordant and discordant pairs of observations. τ is given by the number of concordant pairs minus the discordant pairs divided by the total number of pairs.
Cramér's V (φc)
Cramér's V is an association measure for nominal random variables. The coefficient ranges from 0 to 1, with 0 indicating independence and 1 indicating perfect association. The empirical estimators used for Cramér's V have been proved to be biased, even for large samples. We use a bias-corrected measure that has been proposed by Bergsma in 2013 that can be found here.Phik (φk)
Phik (φk) is a new and practical correlation coefficient that works consistently between categorical, ordinal and interval variables, captures non-linear dependency and reverts to the Pearson correlation coefficient in case of a bivariate normal input distribution. There is extensive documentation available here.First rows
| CodigoTipoAsegurado__c | PuntoVenta__c | tipo_ramo_name | tipo_prod_desc | ClaseVehiculo__c | MarcaVehiculo__c | MdeloVehiculo__c | TipoVehiculo__c | NumeroPoliza__c | FechaInicioVigencia__ctrim | churn | n_prod_prev | total_siniestros | total_pagado_smmlv | anios_ultimo_siniestro | Activos__c | AnnualRevenue | MontoAnual__c | OtrosIngresos__c | Profesion__pc | EgresosAnuales__c | EstadoCivil__pc | Genero__pc | ciudad_name | edad | |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 0 | 2 | 7002 | automoviles | automoviles | 99999 | NaN | NaN | 99999 | 1010166 | 01-2018 | 1 | 1.0 | 78.0 | 188.764267 | 0.005479 | NaN | NaN | NaN | NaN | NaN | NaN | NaN | NaN | NaN | NaN |
| 1 | 4 | 7002 | automoviles | automoviles | 99999 | NaN | NaN | 99999 | 1009970 | 01-2018 | 0 | 1.0 | 1.0 | 4.421380 | 0.427397 | NaN | NaN | NaN | NaN | NaN | NaN | NaN | NaN | NaN | NaN |
| 2 | 2 | 7002 | automoviles | automoviles | 99999 | NaN | NaN | 99999 | 1010430 | 01-2018 | 0 | 1.0 | 543.0 | 2962.748964 | 0.008219 | NaN | NaN | NaN | NaN | NaN | NaN | NaN | NaN | NaN | NaN |
| 3 | 4 | 7002 | automoviles | automoviles | 99999 | NaN | NaN | 99999 | 1010682 | 01-2018 | 0 | 1.0 | 2.0 | 21.781151 | 1.967123 | NaN | NaN | NaN | NaN | NaN | NaN | NaN | NaN | NaN | NaN |
| 4 | 1 | 3202 | automoviles | automoviles | 99999 | NaN | NaN | 99999 | 3065193 | 01-2018 | 1 | 1.0 | NaN | NaN | NaN | 29990000.0 | 14400000.0 | NaN | 0.0 | NaN | 2600000.0 | CASADO | MASCULINO | otras | 31.605479 |
| 5 | 1 | 3202 | automoviles | automoviles | 99999 | NaN | NaN | 99999 | 3065333 | 01-2018 | 1 | 1.0 | NaN | NaN | NaN | 37625000.0 | 70800000.0 | NaN | 0.0 | NaN | 42000000.0 | CASADO | FEMENINO | BOGOTÁ D.C. | 44.312329 |
| 6 | 1 | 3202 | automoviles | automoviles | 99999 | NaN | NaN | 99999 | 3065130 | 01-2018 | 1 | 1.0 | NaN | NaN | NaN | NaN | NaN | NaN | NaN | NaN | NaN | OTRO | FEMENINO | otras | 30.454795 |
| 7 | 1 | 3202 | automoviles | automoviles | 99999 | NaN | NaN | 99999 | 3065773 | 01-2018 | 1 | 1.0 | NaN | NaN | NaN | 200000000.0 | 132000000.0 | NaN | 0.0 | NaN | 60000000.0 | CASADO | MASCULINO | BARRANQUILLA | 26.315068 |
| 8 | 1 | 3202 | automoviles | automoviles | 99999 | NaN | NaN | 99999 | 3054481 | 01-2018 | 1 | 1.0 | NaN | NaN | NaN | 95000000.0 | 22800000.0 | NaN | 0.0 | NaN | 9000000.0 | SOLTERO | MASCULINO | otras | 25.887671 |
| 9 | 1 | 3202 | automoviles | automoviles | 99999 | NaN | NaN | 99999 | 3076126 | 01-2018 | 0 | 14.0 | 704.0 | 5779.809377 | 0.060274 | NaN | NaN | NaN | NaN | NaN | NaN | NaN | NaN | NaN | NaN |
Last rows
| CodigoTipoAsegurado__c | PuntoVenta__c | tipo_ramo_name | tipo_prod_desc | ClaseVehiculo__c | MarcaVehiculo__c | MdeloVehiculo__c | TipoVehiculo__c | NumeroPoliza__c | FechaInicioVigencia__ctrim | churn | n_prod_prev | total_siniestros | total_pagado_smmlv | anios_ultimo_siniestro | Activos__c | AnnualRevenue | MontoAnual__c | OtrosIngresos__c | Profesion__pc | EgresosAnuales__c | EstadoCivil__pc | Genero__pc | ciudad_name | edad | |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 34483 | 1 | 3301 | responsabilidad civil | profesionales medicos | 99999 | NaN | NaN | 99999 | 1003693 | 02-2021 | 1 | NaN | NaN | NaN | NaN | 324578000.0 | 83160000.0 | NaN | 0.0 | NaN | 1.0 | OTRO | MASCULINO | otras | 61.052055 |
| 34484 | 1 | 3301 | responsabilidad civil | directores y administradores | 99999 | NaN | NaN | 99999 | 1027597 | 02-2021 | 1 | NaN | NaN | NaN | NaN | NaN | NaN | NaN | NaN | NaN | NaN | NaN | NaN | NaN | NaN |
| 34485 | 1 | 1048 | responsabilidad civil | directores y administradores | 99999 | NaN | NaN | 99999 | 1020099 | 02-2021 | 1 | NaN | NaN | NaN | NaN | NaN | NaN | NaN | NaN | NaN | NaN | NaN | NaN | NaN | NaN |
| 34486 | 1 | 1048 | responsabilidad civil | directores y administradores | 99999 | NaN | NaN | 99999 | 1023555 | 02-2021 | 1 | NaN | 2.0 | 1.415121 | 0.394521 | NaN | NaN | NaN | NaN | NaN | NaN | NaN | NaN | NaN | NaN |
| 34487 | 1 | 3301 | responsabilidad civil | profesionales medicos | 99999 | NaN | NaN | 99999 | 1027400 | 02-2021 | 1 | NaN | NaN | NaN | NaN | 18000000.0 | 60000000.0 | NaN | 0.0 | NaN | 58000000.0 | CASADO | MASCULINO | BOGOTÁ D.C. | NaN |
| 34488 | 1 | 3301 | responsabilidad civil | directores y administradores | 99999 | NaN | NaN | 99999 | 1027403 | 02-2021 | 1 | 14.0 | 704.0 | 5779.809377 | 0.060274 | NaN | NaN | NaN | NaN | NaN | NaN | NaN | NaN | NaN | NaN |
| 34489 | 3 | 3202 | responsabilidad civil | profesionales medicos | 99999 | NaN | NaN | 99999 | 1060113 | 02-2021 | 1 | NaN | NaN | NaN | NaN | NaN | NaN | NaN | NaN | NaN | NaN | NaN | NaN | NaN | NaN |
| 34490 | 1 | 8001 | responsabilidad civil | profesionales medicos | 99999 | NaN | NaN | 99999 | 1027255 | 02-2021 | 1 | NaN | NaN | NaN | NaN | 500000000.0 | 90000000.0 | NaN | 0.0 | NaN | 65000000.0 | SOLTERO | MASCULINO | BOGOTÁ D.C. | 122.512329 |
| 34491 | 1 | 8001 | responsabilidad civil | directores y administradores | 99999 | NaN | NaN | 99999 | 1027331 | 02-2021 | 0 | NaN | NaN | NaN | NaN | NaN | NaN | NaN | NaN | NaN | NaN | NaN | NaN | NaN | NaN |
| 34492 | 1 | 8001 | responsabilidad civil | directores y administradores | 99999 | NaN | NaN | 99999 | 1027428 | 02-2021 | 1 | NaN | NaN | NaN | NaN | NaN | NaN | NaN | NaN | NaN | NaN | NaN | NaN | NaN | NaN |